Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	583985
Missing cells	654318
Missing cells (%)	5.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	98.0 MiB
Average record size in memory	176.0 B

Variable types

Numeric	11
Categorical	10
Unsupported	1

Alerts

`TAIL_NUM` has a high cardinality: 5446 distinct values	High cardinality
`ORIGIN` has a high cardinality: 346 distinct values	High cardinality
`DEST` has a high cardinality: 346 distinct values	High cardinality
`OP_CARRIER_AIRLINE_ID` is highly overall correlated with `OP_UNIQUE_CARRIER` and 1 other fields	High correlation
`ORIGIN_AIRPORT_ID` is highly overall correlated with `ORIGIN_AIRPORT_SEQ_ID`	High correlation
`ORIGIN_AIRPORT_SEQ_ID` is highly overall correlated with `ORIGIN_AIRPORT_ID`	High correlation
`DEST_AIRPORT_ID` is highly overall correlated with `DEST_AIRPORT_SEQ_ID`	High correlation
`DEST_AIRPORT_SEQ_ID` is highly overall correlated with `DEST_AIRPORT_ID`	High correlation
`DEP_TIME` is highly overall correlated with `ARR_TIME` and 1 other fields	High correlation
`ARR_TIME` is highly overall correlated with `DEP_TIME` and 2 other fields	High correlation
`OP_UNIQUE_CARRIER` is highly overall correlated with `OP_CARRIER_AIRLINE_ID` and 1 other fields	High correlation
`OP_CARRIER` is highly overall correlated with `OP_CARRIER_AIRLINE_ID` and 1 other fields	High correlation
`DEP_DEL15` is highly overall correlated with `ARR_DEL15`	High correlation
`DEP_TIME_BLK` is highly overall correlated with `DEP_TIME` and 1 other fields	High correlation
`ARR_DEL15` is highly overall correlated with `DEP_DEL15` and 2 other fields	High correlation
`CANCELLED` is highly overall correlated with `ARR_TIME` and 1 other fields	High correlation
`DIVERTED` is highly overall correlated with `ARR_DEL15`	High correlation
`CANCELLED` is highly imbalanced (81.2%)	Imbalance
`DIVERTED` is highly imbalanced (97.7%)	Imbalance
`DEP_TIME` has 16352 (2.8%) missing values	Missing
`DEP_DEL15` has 16355 (2.8%) missing values	Missing
`ARR_TIME` has 17061 (2.9%) missing values	Missing
`ARR_DEL15` has 18022 (3.1%) missing values	Missing
`Unnamed: 21` has 583985 (100.0%) missing values	Missing
`Unnamed: 21` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-03-27 15:39:18.665859
Analysis finished	2023-03-27 15:40:08.251346
Duration	49.59 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

DAY_OF_MONTH
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.960088

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	24
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.9879417
Coefficient of variation (CV)	0.56315114
Kurtosis	-1.2118653
Mean	15.960088
Median Absolute Deviation (MAD)	8
Skewness	0.013790461
Sum	9320452
Variance	80.783096
Monotonicity	Increasing

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
2	20384	3.5%
11	20082	3.4%
25	20041	3.4%
7	20015	3.4%
18	20009	3.4%
10	19980	3.4%
24	19963	3.4%
31	19962	3.4%
17	19960	3.4%
14	19941	3.4%
Other values (21)	383648	65.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	18009	3.1%
2	20384	3.5%
3	19522	3.3%
4	19566	3.4%
5	16807	2.9%
6	19448	3.3%
7	20015	3.4%
8	18815	3.2%
9	19236	3.3%
10	19980	3.4%

Value	Count	Frequency (%)
31	19962	3.4%
30	19102	3.3%
29	18662	3.2%
28	19934	3.4%
27	18575	3.2%
26	15267	2.6%
25	20041	3.4%
24	19963	3.4%
23	19099	3.3%
22	18657	3.2%

DAY_OF_WEEK
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8356259

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.9218991
Coefficient of variation (CV)	0.50106531
Kurtosis	-1.1030354
Mean	3.8356259
Median Absolute Deviation (MAD)	2
Skewness	0.15555045
Sum	2239948
Variance	3.6936961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	99387	17.0%
3	96920	16.6%
2	92796	15.9%
5	79698	13.6%
1	79401	13.6%
7	73459	12.6%
6	62324	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	79401	13.6%
2	92796	15.9%
3	96920	16.6%
4	99387	17.0%
5	79698	13.6%
6	62324	10.7%
7	73459	12.6%

Value	Count	Frequency (%)
7	73459	12.6%
6	62324	10.7%
5	79698	13.6%
4	99387	17.0%
3	96920	16.6%
2	92796	15.9%
1	79401	13.6%

OP_UNIQUE_CARRIER
Categorical

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

WN	111312
AA	77017
DL	73836
OO	64926
UA	46915
Other values (12)	209979

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1167970
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9E
2nd row	9E
3rd row	9E
4th row	9E
5th row	9E

Common Values

Value	Count	Frequency (%)
WN	111312	19.1%
AA	77017	13.2%
DL	73836	12.6%
OO	64926	11.1%
UA	46915	8.0%
YX	25755	4.4%
MQ	25699	4.4%
B6	24443	4.2%
OH	23169	4.0%
AS	20744	3.6%
Other values (7)	90169	15.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wn	111312	19.1%
aa	77017	13.2%
dl	73836	12.6%
oo	64926	11.1%
ua	46915	8.0%
yx	25755	4.4%
mq	25699	4.4%
b6	24443	4.2%
oh	23169	4.0%
as	20744	3.6%
Other values (7)	90169	15.4%

Most occurring characters

Value	Count	Frequency (%)
A	228491	19.6%
O	153021	13.1%
N	126534	10.8%
W	111312	9.5%
D	73836	6.3%
L	73836	6.3%
U	46915	4.0%
Y	44101	3.8%
E	33393	2.9%
V	31541	2.7%
Other values (12)	244990	21.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1106919	94.8%
Decimal Number	61051	5.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	228491	20.6%
O	153021	13.8%
N	126534	11.4%
W	111312	10.1%
D	73836	6.7%
L	73836	6.7%
U	46915	4.2%
Y	44101	4.0%
E	33393	3.0%
V	31541	2.8%
Other values (9)	183939	16.6%

Decimal Number

Value	Count	Frequency (%)
9	29845	48.9%
6	24443	40.0%
4	6763	11.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1106919	94.8%
Common	61051	5.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	228491	20.6%
O	153021	13.8%
N	126534	11.4%
W	111312	10.1%
D	73836	6.7%
L	73836	6.7%
U	46915	4.2%
Y	44101	4.0%
E	33393	3.0%
V	31541	2.8%
Other values (9)	183939	16.6%

Common

Value	Count	Frequency (%)
9	29845	48.9%
6	24443	40.0%
4	6763	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1167970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	228491	19.6%
O	153021	13.1%
N	126534	10.8%
W	111312	9.5%
D	73836	6.3%
L	73836	6.3%
U	46915	4.0%
Y	44101	3.8%
E	33393	2.9%
V	31541	2.7%
Other values (12)	244990	21.0%

OP_CARRIER_AIRLINE_ID
Real number (ℝ)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19983.213

Minimum	19393
Maximum	20452
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	19393
5-th percentile	19393
Q1	19790
median	19977
Q3	20368
95-th percentile	20436
Maximum	20452
Range	1059
Interquartile range (IQR)	578

Descriptive statistics

Standard deviation	377.72464
Coefficient of variation (CV)	0.018902097
Kurtosis	-1.3049711
Mean	19983.213
Median Absolute Deviation (MAD)	386
Skewness	-0.26626807
Sum	1.1669897 × 10¹⁰
Variance	142675.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
19393	111312	19.1%
19805	77017	13.2%
19790	73836	12.6%
20304	64926	11.1%
19977	46915	8.0%
20452	25755	4.4%
20398	25699	4.4%
20409	24443	4.2%
20397	23169	4.0%
19930	20744	3.6%
Other values (7)	90169	15.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19393	111312	19.1%
19690	6798	1.2%
19790	73836	12.6%
19805	77017	13.2%
19930	20744	3.6%
19977	46915	8.0%
20304	64926	11.1%
20363	20198	3.5%
20366	13195	2.3%
20368	6763	1.2%

Value	Count	Frequency (%)
20452	25755	4.4%
20436	9647	1.7%
20416	15222	2.6%
20409	24443	4.2%
20398	25699	4.4%
20397	23169	4.0%
20378	18346	3.1%
20368	6763	1.2%
20366	13195	2.3%
20363	20198	3.5%

OP_CARRIER
Categorical

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

WN	111312
AA	77017
DL	73836
OO	64926
UA	46915
Other values (12)	209979

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1167970
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9E
2nd row	9E
3rd row	9E
4th row	9E
5th row	9E

Common Values

Value	Count	Frequency (%)
WN	111312	19.1%
AA	77017	13.2%
DL	73836	12.6%
OO	64926	11.1%
UA	46915	8.0%
YX	25755	4.4%
MQ	25699	4.4%
B6	24443	4.2%
OH	23169	4.0%
AS	20744	3.6%
Other values (7)	90169	15.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wn	111312	19.1%
aa	77017	13.2%
dl	73836	12.6%
oo	64926	11.1%
ua	46915	8.0%
yx	25755	4.4%
mq	25699	4.4%
b6	24443	4.2%
oh	23169	4.0%
as	20744	3.6%
Other values (7)	90169	15.4%

Most occurring characters

Value	Count	Frequency (%)
A	228491	19.6%
O	153021	13.1%
N	126534	10.8%
W	111312	9.5%
D	73836	6.3%
L	73836	6.3%
U	46915	4.0%
Y	44101	3.8%
E	33393	2.9%
V	31541	2.7%
Other values (12)	244990	21.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1106919	94.8%
Decimal Number	61051	5.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	228491	20.6%
O	153021	13.8%
N	126534	11.4%
W	111312	10.1%
D	73836	6.7%
L	73836	6.7%
U	46915	4.2%
Y	44101	4.0%
E	33393	3.0%
V	31541	2.8%
Other values (9)	183939	16.6%

Decimal Number

Value	Count	Frequency (%)
9	29845	48.9%
6	24443	40.0%
4	6763	11.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1106919	94.8%
Common	61051	5.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	228491	20.6%
O	153021	13.8%
N	126534	11.4%
W	111312	10.1%
D	73836	6.7%
L	73836	6.7%
U	46915	4.2%
Y	44101	4.0%
E	33393	3.0%
V	31541	2.8%
Other values (9)	183939	16.6%

Common

Value	Count	Frequency (%)
9	29845	48.9%
6	24443	40.0%
4	6763	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1167970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	228491	19.6%
O	153021	13.1%
N	126534	10.8%
W	111312	9.5%
D	73836	6.3%
L	73836	6.3%
U	46915	4.0%
Y	44101	3.8%
E	33393	2.9%
V	31541	2.7%
Other values (12)	244990	21.0%

TAIL_NUM
Categorical

Distinct	5446
Distinct (%)	0.9%
Missing	2543
Missing (%)	0.4%
Memory size	4.5 MiB

N488HA	361
N481HA	348
N483HA	346
N489HA	344
N493HA	328
Other values (5441)	579715

Length

Max length	6
Median length	6
Mean length	5.986033
Min length	3

Characters and Unicode

Total characters	3480531
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28 ?
Unique (%)	< 0.1%

Sample

1st row	N8688C
2nd row	N348PQ
3rd row	N8896A
4th row	N8886A
5th row	N8974C

Common Values

Value	Count	Frequency (%)
N488HA	361	0.1%
N481HA	348	0.1%
N483HA	346	0.1%
N489HA	344	0.1%
N493HA	328	0.1%
N485HA	315	0.1%
N492HA	305	0.1%
N486HA	290	< 0.1%
N480HA	281	< 0.1%
N479HA	280	< 0.1%
Other values (5436)	578244	99.0%
(Missing)	2543	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
n488ha	361	0.1%
n481ha	348	0.1%
n483ha	346	0.1%
n489ha	344	0.1%
n493ha	328	0.1%
n485ha	315	0.1%
n492ha	305	0.1%
n486ha	290	< 0.1%
n480ha	281	< 0.1%
n479ha	280	< 0.1%
Other values (5436)	578244	99.4%

Most occurring characters

Value	Count	Frequency (%)
N	757622	21.8%
8	229511	6.6%
9	214602	6.2%
7	203303	5.8%
2	199511	5.7%
3	195711	5.6%
5	188043	5.4%
1	182038	5.2%
6	181942	5.2%
4	175544	5.0%
Other values (24)	952704	27.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1901962	54.6%
Uppercase Letter	1578569	45.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	757622	48.0%
A	141091	8.9%
W	110015	7.0%
S	93262	5.9%
D	46495	2.9%
U	44283	2.8%
J	41335	2.6%
B	40318	2.6%
E	36500	2.3%
K	34466	2.2%
Other values (14)	233182	14.8%

Decimal Number

Value	Count	Frequency (%)
8	229511	12.1%
9	214602	11.3%
7	203303	10.7%
2	199511	10.5%
3	195711	10.3%
5	188043	9.9%
1	182038	9.6%
6	181942	9.6%
4	175544	9.2%
0	131757	6.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1901962	54.6%
Latin	1578569	45.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	757622	48.0%
A	141091	8.9%
W	110015	7.0%
S	93262	5.9%
D	46495	2.9%
U	44283	2.8%
J	41335	2.6%
B	40318	2.6%
E	36500	2.3%
K	34466	2.2%
Other values (14)	233182	14.8%

Common

Value	Count	Frequency (%)
8	229511	12.1%
9	214602	11.3%
7	203303	10.7%
2	199511	10.5%
3	195711	10.3%
5	188043	9.9%
1	182038	9.6%
6	181942	9.6%
4	175544	9.2%
0	131757	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3480531	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	757622	21.8%
8	229511	6.6%
9	214602	6.2%
7	203303	5.8%
2	199511	5.7%
3	195711	5.6%
5	188043	5.4%
1	182038	5.2%
6	181942	5.2%
4	175544	5.0%
Other values (24)	952704	27.4%

OP_CARRIER_FL_NUM
Real number (ℝ)

Distinct	6839
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2537.8693

Minimum	1
Maximum	7439
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	232
Q1	979
median	2114
Q3	3902
95-th percentile	5831
Maximum	7439
Range	7438
Interquartile range (IQR)	2923

Descriptive statistics

Standard deviation	1821.7361
Coefficient of variation (CV)	0.7178211
Kurtosis	-0.82533758
Mean	2537.8693
Median Absolute Deviation (MAD)	1386
Skewness	0.54136521
Sum	1.4820776 × 10⁹
Variance	3318722.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
403	310	0.1%
761	291	< 0.1%
465	287	< 0.1%
466	285	< 0.1%
546	283	< 0.1%
1106	282	< 0.1%
425	281	< 0.1%
794	278	< 0.1%
347	277	< 0.1%
55	276	< 0.1%
Other values (6829)	581135	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	136	< 0.1%
2	122	< 0.1%
3	159	< 0.1%
4	180	< 0.1%
5	105	< 0.1%
6	81	< 0.1%
7	169	< 0.1%
8	206	< 0.1%
9	162	< 0.1%
10	122	< 0.1%

Value	Count	Frequency (%)
7439	54	< 0.1%
7438	54	< 0.1%
7437	27	< 0.1%
7436	31	< 0.1%
7435	7	< 0.1%
7434	41	< 0.1%
7433	31	< 0.1%
7432	62	< 0.1%
7431	27	< 0.1%
7430	31	< 0.1%

ORIGIN_AIRPORT_ID
Real number (ℝ)

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12659.702

Minimum	10135
Maximum	16218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	10135
5-th percentile	10397
Q1	11292
median	12889
Q3	13931
95-th percentile	14893
Maximum	16218
Range	6083
Interquartile range (IQR)	2639

Descriptive statistics

Standard deviation	1519.4055
Coefficient of variation (CV)	0.12001906
Kurtosis	-1.2976461
Mean	12659.702
Median Absolute Deviation (MAD)	1456
Skewness	0.088227442
Sum	7.3930761 × 10⁹
Variance	2308593.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10397	31155	5.3%
13930	26216	4.5%
11298	23063	3.9%
11057	19100	3.3%
11292	18507	3.2%
12892	17988	3.1%
14107	14761	2.5%
12266	14598	2.5%
12953	13872	2.4%
14771	13689	2.3%
Other values (336)	391036	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10135	339	0.1%
10136	170	< 0.1%
10140	1731	0.3%
10141	62	< 0.1%
10146	84	< 0.1%
10155	116	< 0.1%
10157	129	< 0.1%
10158	298	0.1%
10165	9	< 0.1%
10170	53	< 0.1%

Value	Count	Frequency (%)
16218	115	< 0.1%
15991	60	< 0.1%
15919	1048	0.2%
15841	62	< 0.1%
15624	494	0.1%
15607	87	< 0.1%
15582	53	< 0.1%
15454	58	< 0.1%
15412	1350	0.2%
15411	116	< 0.1%

ORIGIN_AIRPORT_SEQ_ID
Real number (ℝ)

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1265974.1

Minimum	1013505
Maximum	1621802
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1013505
5-th percentile	1039707
Q1	1129202
median	1288903
Q3	1393102
95-th percentile	1489302
Maximum	1621802
Range	608297
Interquartile range (IQR)	263900

Descriptive statistics

Standard deviation	151940.3
Coefficient of variation (CV)	0.12001849
Kurtosis	-1.2976523
Mean	1265974.1
Median Absolute Deviation (MAD)	145601
Skewness	0.08822968
Sum	7.393099 × 10¹¹
Variance	2.3085855 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1039707	31155	5.3%
1393007	26216	4.5%
1129806	23063	3.9%
1105703	19100	3.3%
1129202	18507	3.2%
1289208	17988	3.1%
1410702	14761	2.5%
1226603	14598	2.5%
1295304	13872	2.4%
1477104	13689	2.3%
Other values (336)	391036	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1013505	339	0.1%
1013603	170	< 0.1%
1014005	1731	0.3%
1014106	62	< 0.1%
1014602	84	< 0.1%
1015502	116	< 0.1%
1015706	129	< 0.1%
1015804	298	0.1%
1016506	9	< 0.1%
1017004	53	< 0.1%

Value	Count	Frequency (%)
1621802	115	< 0.1%
1599102	60	< 0.1%
1591904	1048	0.2%
1584102	62	< 0.1%
1562404	494	0.1%
1560702	87	< 0.1%
1558203	53	< 0.1%
1545405	58	< 0.1%
1541205	1350	0.2%
1541106	116	< 0.1%

ORIGIN
Categorical

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

ATL	31155
ORD	26216
DFW	23063
CLT	19100
DEN	18507
Other values (341)	465944

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1751955
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GNV
2nd row	MSP
3rd row	DTW
4th row	TLH
5th row	ATL

Common Values

Value	Count	Frequency (%)
ATL	31155	5.3%
ORD	26216	4.5%
DFW	23063	3.9%
CLT	19100	3.3%
DEN	18507	3.2%
LAX	17988	3.1%
PHX	14761	2.5%
IAH	14598	2.5%
LGA	13872	2.4%
SFO	13689	2.3%
Other values (336)	391036	67.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
atl	31155	5.3%
ord	26216	4.5%
dfw	23063	3.9%
clt	19100	3.3%
den	18507	3.2%
lax	17988	3.1%
phx	14761	2.5%
iah	14598	2.5%
lga	13872	2.4%
sfo	13689	2.3%
Other values (336)	391036	67.0%

Most occurring characters

Value	Count	Frequency (%)
A	197390	11.3%
L	168284	9.6%
S	143334	8.2%
D	135780	7.8%
T	100119	5.7%
O	93364	5.3%
C	90737	5.2%
M	77481	4.4%
F	73904	4.2%
P	68946	3.9%
Other values (16)	602616	34.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1751955	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	197390	11.3%
L	168284	9.6%
S	143334	8.2%
D	135780	7.8%
T	100119	5.7%
O	93364	5.3%
C	90737	5.2%
M	77481	4.4%
F	73904	4.2%
P	68946	3.9%
Other values (16)	602616	34.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1751955	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	197390	11.3%
L	168284	9.6%
S	143334	8.2%
D	135780	7.8%
T	100119	5.7%
O	93364	5.3%
C	90737	5.2%
M	77481	4.4%
F	73904	4.2%
P	68946	3.9%
Other values (16)	602616	34.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1751955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	197390	11.3%
L	168284	9.6%
S	143334	8.2%
D	135780	7.8%
T	100119	5.7%
O	93364	5.3%
C	90737	5.2%
M	77481	4.4%
F	73904	4.2%
P	68946	3.9%
Other values (16)	602616	34.4%

DEST_AIRPORT_ID
Real number (ℝ)

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12659.47

Minimum	10135
Maximum	16218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	10135
5-th percentile	10397
Q1	11292
median	12889
Q3	13931
95-th percentile	14893
Maximum	16218
Range	6083
Interquartile range (IQR)	2639

Descriptive statistics

Standard deviation	1519.3365
Coefficient of variation (CV)	0.1200158
Kurtosis	-1.2977051
Mean	12659.47
Median Absolute Deviation (MAD)	1456
Skewness	0.088333171
Sum	7.3929406 × 10⁹
Variance	2308383.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10397	31151	5.3%
13930	26212	4.5%
11298	23078	4.0%
11057	19105	3.3%
11292	18498	3.2%
12892	17977	3.1%
14107	14764	2.5%
12266	14586	2.5%
12953	13882	2.4%
14771	13702	2.3%
Other values (336)	391030	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10135	340	0.1%
10136	170	< 0.1%
10140	1732	0.3%
10141	62	< 0.1%
10146	84	< 0.1%
10155	116	< 0.1%
10157	130	< 0.1%
10158	298	0.1%
10165	9	< 0.1%
10170	53	< 0.1%

Value	Count	Frequency (%)
16218	115	< 0.1%
15991	60	< 0.1%
15919	1049	0.2%
15841	62	< 0.1%
15624	494	0.1%
15607	87	< 0.1%
15582	53	< 0.1%
15454	59	< 0.1%
15412	1350	0.2%
15411	116	< 0.1%

DEST_AIRPORT_SEQ_ID
Real number (ℝ)

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1265950.9

Minimum	1013505
Maximum	1621802
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1013505
5-th percentile	1039707
Q1	1129202
median	1288903
Q3	1393102
95-th percentile	1489302
Maximum	1621802
Range	608297
Interquartile range (IQR)	263900

Descriptive statistics

Standard deviation	151933.4
Coefficient of variation (CV)	0.12001523
Kurtosis	-1.2977113
Mean	1265950.9
Median Absolute Deviation (MAD)	145601
Skewness	0.088335412
Sum	7.3929635 × 10¹¹
Variance	2.3083757 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1039707	31151	5.3%
1393007	26212	4.5%
1129806	23078	4.0%
1105703	19105	3.3%
1129202	18498	3.2%
1289208	17977	3.1%
1410702	14764	2.5%
1226603	14586	2.5%
1295304	13882	2.4%
1477104	13702	2.3%
Other values (336)	391030	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1013505	340	0.1%
1013603	170	< 0.1%
1014005	1732	0.3%
1014106	62	< 0.1%
1014602	84	< 0.1%
1015502	116	< 0.1%
1015706	130	< 0.1%
1015804	298	0.1%
1016506	9	< 0.1%
1017004	53	< 0.1%

Value	Count	Frequency (%)
1621802	115	< 0.1%
1599102	60	< 0.1%
1591904	1049	0.2%
1584102	62	< 0.1%
1562404	494	0.1%
1560702	87	< 0.1%
1558203	53	< 0.1%
1545405	59	< 0.1%
1541205	1350	0.2%
1541106	116	< 0.1%

DEST
Categorical

Distinct	346
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

ATL	31151
ORD	26212
DFW	23078
CLT	19105
DEN	18498
Other values (341)	465941

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1751955
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ATL
2nd row	CVG
3rd row	CVG
4th row	ATL
5th row	FSM

Common Values

Value	Count	Frequency (%)
ATL	31151	5.3%
ORD	26212	4.5%
DFW	23078	4.0%
CLT	19105	3.3%
DEN	18498	3.2%
LAX	17977	3.1%
PHX	14764	2.5%
IAH	14586	2.5%
LGA	13882	2.4%
SFO	13702	2.3%
Other values (336)	391030	67.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
atl	31151	5.3%
ord	26212	4.5%
dfw	23078	4.0%
clt	19105	3.3%
den	18498	3.2%
lax	17977	3.1%
phx	14764	2.5%
iah	14586	2.5%
lga	13882	2.4%
sfo	13702	2.3%
Other values (336)	391030	67.0%

Most occurring characters

Value	Count	Frequency (%)
A	197382	11.3%
L	168337	9.6%
S	143375	8.2%
D	135775	7.7%
T	100066	5.7%
O	93371	5.3%
C	90766	5.2%
M	77477	4.4%
F	73910	4.2%
P	68937	3.9%
Other values (16)	602559	34.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1751955	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	197382	11.3%
L	168337	9.6%
S	143375	8.2%
D	135775	7.7%
T	100066	5.7%
O	93371	5.3%
C	90766	5.2%
M	77477	4.4%
F	73910	4.2%
P	68937	3.9%
Other values (16)	602559	34.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1751955	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	197382	11.3%
L	168337	9.6%
S	143375	8.2%
D	135775	7.7%
T	100066	5.7%
O	93371	5.3%
C	90766	5.2%
M	77477	4.4%
F	73910	4.2%
P	68937	3.9%
Other values (16)	602559	34.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1751955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	197382	11.3%
L	168337	9.6%
S	143375	8.2%
D	135775	7.7%
T	100066	5.7%
O	93371	5.3%
C	90766	5.2%
M	77477	4.4%
F	73910	4.2%
P	68937	3.9%
Other values (16)	602559	34.4%

DEP_TIME
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1438
Distinct (%)	0.3%
Missing	16352
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	1331.9578

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	603
Q1	921
median	1328
Q3	1738
95-th percentile	2128
Maximum	2400
Range	2399
Interquartile range (IQR)	817

Descriptive statistics

Standard deviation	495.40402
Coefficient of variation (CV)	0.37193672
Kurtosis	-0.98525653
Mean	1331.9578
Median Absolute Deviation (MAD)	409
Skewness	0.024633579
Sum	7.5606321 × 10⁸
Variance	245425.14
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
555	1382	0.2%
557	1237	0.2%
556	1205	0.2%
554	1191	0.2%
558	1136	0.2%
655	1123	0.2%
559	1074	0.2%
553	1067	0.2%
654	1014	0.2%
656	1010	0.2%
Other values (1428)	556194	95.2%
(Missing)	16352	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	45	< 0.1%
2	49	< 0.1%
3	47	< 0.1%
4	43	< 0.1%
5	33	< 0.1%
6	33	< 0.1%
7	31	< 0.1%
8	33	< 0.1%
9	26	< 0.1%
10	40	< 0.1%

Value	Count	Frequency (%)
2400	46	< 0.1%
2359	52	< 0.1%
2358	64	< 0.1%
2357	57	< 0.1%
2356	70	< 0.1%
2355	79	< 0.1%
2354	75	< 0.1%
2353	93	< 0.1%
2352	72	< 0.1%
2351	83	< 0.1%

DEP_DEL15
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	16355
Missing (%)	2.8%
Memory size	4.5 MiB

0.0	468703
1.0	98927

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1702890
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	468703	80.3%
1.0	98927	16.9%
(Missing)	16355	2.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	468703	82.6%
1.0	98927	17.4%

Most occurring characters

Value	Count	Frequency (%)
0	1036333	60.9%
.	567630	33.3%
1	98927	5.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1135260	66.7%
Other Punctuation	567630	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1036333	91.3%
1	98927	8.7%

Other Punctuation

Value	Count	Frequency (%)
.	567630	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1702890	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1036333	60.9%
.	567630	33.3%
1	98927	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1702890	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1036333	60.9%
.	567630	33.3%
1	98927	5.8%

DEP_TIME_BLK
Categorical

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

0600-0659	41971
0800-0859	39031
0700-0759	38450
1700-1759	37254
1200-1259	36918
Other values (14)	390361

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	5255865
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0600-0659
2nd row	1400-1459
3rd row	1200-1259
4th row	1500-1559
5th row	1900-1959

Common Values

Value	Count	Frequency (%)
0600-0659	41971	7.2%
0800-0859	39031	6.7%
0700-0759	38450	6.6%
1700-1759	37254	6.4%
1200-1259	36918	6.3%
1100-1159	36774	6.3%
1500-1559	35988	6.2%
1400-1459	35925	6.2%
1000-1059	35768	6.1%
1600-1659	35250	6.0%
Other values (9)	210656	36.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0600-0659	41971	7.2%
0800-0859	39031	6.7%
0700-0759	38450	6.6%
1700-1759	37254	6.4%
1200-1259	36918	6.3%
1100-1159	36774	6.3%
1500-1559	35988	6.2%
1400-1459	35925	6.2%
1000-1059	35768	6.1%
1600-1659	35250	6.0%
Other values (9)	210656	36.1%

Most occurring characters

Value	Count	Frequency (%)
0	1631046	31.0%
1	832679	15.8%
9	716399	13.6%
5	671838	12.8%
-	583985	11.1%
2	220852	4.2%
6	154442	2.9%
7	151408	2.9%
8	147402	2.8%
3	73964	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4671880	88.9%
Dash Punctuation	583985	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1631046	34.9%
1	832679	17.8%
9	716399	15.3%
5	671838	14.4%
2	220852	4.7%
6	154442	3.3%
7	151408	3.2%
8	147402	3.2%
3	73964	1.6%
4	71850	1.5%

Dash Punctuation

Value	Count	Frequency (%)
-	583985	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5255865	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1631046	31.0%
1	832679	15.8%
9	716399	13.6%
5	671838	12.8%
-	583985	11.1%
2	220852	4.2%
6	154442	2.9%
7	151408	2.9%
8	147402	2.8%
3	73964	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5255865	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1631046	31.0%
1	832679	15.8%
9	716399	13.6%
5	671838	12.8%
-	583985	11.1%
2	220852	4.2%
6	154442	2.9%
7	151408	2.9%
8	147402	2.8%
3	73964	1.4%

ARR_TIME
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1440
Distinct (%)	0.3%
Missing	17061
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	1484.3159

Minimum	1
Maximum	2400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	1
5-th percentile	707
Q1	1104
median	1517
Q3	1919
95-th percentile	2251
Maximum	2400
Range	2399
Interquartile range (IQR)	815

Descriptive statistics

Standard deviation	523.16285
Coefficient of variation (CV)	0.35246058
Kurtosis	-0.37072307
Mean	1484.3159
Median Absolute Deviation (MAD)	408
Skewness	-0.35448191
Sum	8.4149432 × 10⁸
Variance	273699.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1645	674	0.1%
2015	664	0.1%
1015	661	0.1%
1910	657	0.1%
1008	656	0.1%
2056	654	0.1%
1400	651	0.1%
2042	650	0.1%
1633	650	0.1%
1838	650	0.1%
Other values (1430)	560357	96.0%
(Missing)	17061	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	301	0.1%
2	246	< 0.1%
3	240	< 0.1%
4	237	< 0.1%
5	249	< 0.1%
6	243	< 0.1%
7	222	< 0.1%
8	212	< 0.1%
9	234	< 0.1%
10	215	< 0.1%

Value	Count	Frequency (%)
2400	252	< 0.1%
2359	278	< 0.1%
2358	320	0.1%
2357	304	0.1%
2356	301	0.1%
2355	263	< 0.1%
2354	327	0.1%
2353	344	0.1%
2352	362	0.1%
2351	332	0.1%

ARR_DEL15
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	18022
Missing (%)	3.1%
Memory size	4.5 MiB

0.0	460741
1.0	105222

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1697889
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	460741	78.9%
1.0	105222	18.0%
(Missing)	18022	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	460741	81.4%
1.0	105222	18.6%

Most occurring characters

Value	Count	Frequency (%)
0	1026704	60.5%
.	565963	33.3%
1	105222	6.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1131926	66.7%
Other Punctuation	565963	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1026704	90.7%
1	105222	9.3%

Other Punctuation

Value	Count	Frequency (%)
.	565963	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1697889	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1026704	60.5%
.	565963	33.3%
1	105222	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1697889	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1026704	60.5%
.	565963	33.3%
1	105222	6.2%

CANCELLED
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

0.0	567259
1.0	16726

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1751955
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	567259	97.1%
1.0	16726	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	567259	97.1%
1.0	16726	2.9%

Most occurring characters

Value	Count	Frequency (%)
0	1151244	65.7%
.	583985	33.3%
1	16726	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1167970	66.7%
Other Punctuation	583985	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1151244	98.6%
1	16726	1.4%

Other Punctuation

Value	Count	Frequency (%)
.	583985	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1751955	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1151244	65.7%
.	583985	33.3%
1	16726	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1751955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1151244	65.7%
.	583985	33.3%
1	16726	1.0%

DIVERTED
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.5 MiB

0.0	582689
1.0	1296

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1751955
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	582689	99.8%
1.0	1296	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	582689	99.8%
1.0	1296	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	1166674	66.6%
.	583985	33.3%
1	1296	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1167970	66.7%
Other Punctuation	583985	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1166674	99.9%
1	1296	0.1%

Other Punctuation

Value	Count	Frequency (%)
.	583985	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1751955	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1166674	66.6%
.	583985	33.3%
1	1296	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1751955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1166674	66.6%
.	583985	33.3%
1	1296	0.1%

DISTANCE
Real number (ℝ)

Distinct	1451
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	797.74277

Minimum	31
Maximum	4983
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 MiB

Quantile statistics

Minimum	31
5-th percentile	168
Q1	363
median	640
Q3	1037
95-th percentile	2139
Maximum	4983
Range	4952
Interquartile range (IQR)	674

Descriptive statistics

Standard deviation	589.99926
Coefficient of variation (CV)	0.73958585
Kurtosis	2.6283324
Mean	797.74277
Median Absolute Deviation (MAD)	317
Skewness	1.4890764
Sum	4.6586981 × 10⁸
Variance	348099.13
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
337	4167	0.7%
296	3277	0.6%
733	2875	0.5%
214	2463	0.4%
594	2411	0.4%
404	2383	0.4%
236	2330	0.4%
447	2297	0.4%
328	2211	0.4%
335	2192	0.4%
Other values (1441)	557379	95.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
31	62	< 0.1%
45	94	< 0.1%
66	62	< 0.1%
67	351	0.1%
68	124	< 0.1%
69	138	< 0.1%
73	390	0.1%
74	383	0.1%
75	532	0.1%
76	204	< 0.1%

Value	Count	Frequency (%)
4983	66	< 0.1%
4962	62	< 0.1%
4817	18	< 0.1%
4502	62	< 0.1%
4243	72	< 0.1%
4184	40	< 0.1%
3972	46	< 0.1%
3904	62	< 0.1%
3801	62	< 0.1%
3784	124	< 0.1%

Unnamed: 21
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	583985
Missing (%)	100.0%
Memory size	4.5 MiB

Auto

Heatmap
Table

	DAY_OF_MONTH	DAY_OF_WEEK	OP_CARRIER_AIRLINE_ID	OP_CARRIER_FL_NUM	ORIGIN_AIRPORT_ID	ORIGIN_AIRPORT_SEQ_ID	DEST_AIRPORT_ID	DEST_AIRPORT_SEQ_ID	DEP_TIME	ARR_TIME	DISTANCE	OP_UNIQUE_CARRIER	OP_CARRIER	DEP_DEL15	DEP_TIME_BLK	ARR_DEL15	CANCELLED	DIVERTED
DAY_OF_MONTH	1.000	-0.030	-0.004	-0.010	-0.005	-0.005	-0.005	-0.005	-0.002	0.003	-0.020	0.016	0.016	0.104	0.009	0.109	0.144	0.014
DAY_OF_WEEK	-0.030	1.000	0.011	0.060	0.006	0.006	0.006	0.006	0.003	0.005	0.020	0.025	0.025	0.039	0.019	0.039	0.044	0.006
OP_CARRIER_AIRLINE_ID	-0.004	0.011	1.000	0.339	-0.032	-0.032	-0.032	-0.032	0.008	-0.017	-0.098	1.000	1.000	0.063	0.058	0.084	0.075	0.025
OP_CARRIER_FL_NUM	-0.010	0.060	0.339	1.000	-0.053	-0.053	-0.059	-0.059	0.009	-0.002	-0.334	0.469	0.469	0.037	0.040	0.055	0.064	0.012
ORIGIN_AIRPORT_ID	-0.005	0.006	-0.032	-0.053	1.000	1.000	0.019	0.019	-0.033	-0.002	0.092	0.184	0.184	0.036	0.056	0.042	0.052	0.004
ORIGIN_AIRPORT_SEQ_ID	-0.005	0.006	-0.032	-0.053	1.000	1.000	0.019	0.019	-0.033	-0.002	0.092	0.184	0.184	0.036	0.056	0.042	0.052	0.004
DEST_AIRPORT_ID	-0.005	0.006	-0.032	-0.059	0.019	0.019	1.000	1.000	0.026	0.022	0.092	0.184	0.184	0.041	0.043	0.047	0.054	0.015
DEST_AIRPORT_SEQ_ID	-0.005	0.006	-0.032	-0.059	0.019	0.019	1.000	1.000	0.026	0.022	0.092	0.184	0.184	0.041	0.043	0.047	0.054	0.015
DEP_TIME	-0.002	0.003	0.008	0.009	-0.033	-0.033	0.026	0.026	1.000	0.781	-0.039	0.051	0.051	0.214	0.769	0.162	0.009	0.009
ARR_TIME	0.003	0.005	-0.017	-0.002	-0.002	-0.002	0.022	0.022	0.781	1.000	0.055	0.054	0.054	0.243	0.558	0.218	1.000	0.023
DISTANCE	-0.020	0.020	-0.098	-0.334	0.092	0.092	0.092	0.092	-0.039	0.055	1.000	0.182	0.182	0.023	0.076	0.019	0.049	0.017
OP_UNIQUE_CARRIER	0.016	0.025	1.000	0.469	0.184	0.184	0.184	0.184	0.051	0.054	0.182	1.000	1.000	0.090	0.052	0.109	0.107	0.028
OP_CARRIER	0.016	0.025	1.000	0.469	0.184	0.184	0.184	0.184	0.051	0.054	0.182	1.000	1.000	0.090	0.052	0.109	0.107	0.028
DEP_DEL15	0.104	0.039	0.063	0.037	0.036	0.036	0.041	0.041	0.214	0.243	0.023	0.090	0.090	1.000	0.146	0.719	0.022	0.021
DEP_TIME_BLK	0.009	0.019	0.058	0.040	0.056	0.056	0.043	0.043	0.769	0.558	0.076	0.052	0.052	0.146	1.000	0.102	0.022	0.008
ARR_DEL15	0.109	0.039	0.084	0.055	0.042	0.042	0.047	0.047	0.162	0.218	0.019	0.109	0.109	0.719	0.102	1.000	1.000	1.000
CANCELLED	0.144	0.044	0.075	0.064	0.052	0.052	0.054	0.054	0.009	1.000	0.049	0.107	0.107	0.022	0.022	1.000	1.000	0.008
DIVERTED	0.014	0.006	0.025	0.012	0.004	0.004	0.015	0.015	0.009	0.023	0.017	0.028	0.028	0.021	0.008	1.000	0.008	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	DAY_OF_MONTH	DAY_OF_WEEK	OP_UNIQUE_CARRIER	OP_CARRIER_AIRLINE_ID	OP_CARRIER	TAIL_NUM	OP_CARRIER_FL_NUM	ORIGIN_AIRPORT_ID	ORIGIN_AIRPORT_SEQ_ID	ORIGIN	DEST_AIRPORT_ID	DEST_AIRPORT_SEQ_ID	DEST	DEP_TIME	DEP_TIME_BLK	ARR_TIME	DISTANCE	Unnamed: 21
0	1	2	9E	20363	9E	N8688C	3280	11953	1195302	GNV	10397	1039707	ATL	601.0	0600-0659	722.0	300.0	NaN
1	1	2	9E	20363	9E	N348PQ	3281	13487	1348702	MSP	11193	1119302	CVG	1359.0	1400-1459	1633.0	596.0	NaN
2	1	2	9E	20363	9E	N8896A	3282	11433	1143302	DTW	11193	1119302	CVG	1215.0	1200-1259	1329.0	229.0	NaN
3	1	2	9E	20363	9E	N8886A	3283	15249	1524906	TLH	10397	1039707	ATL	1521.0	1500-1559	1625.0	223.0	NaN
4	1	2	9E	20363	9E	N8974C	3284	10397	1039707	ATL	11778	1177801	FSM	1847.0	1900-1959	1940.0	579.0	NaN
5	1	2	9E	20363	9E	N927EV	3285	11267	1126702	DAY	13487	1348702	MSP	853.0	0900-0959	953.0	574.0	NaN
6	1	2	9E	20363	9E	N915XJ	3286	12448	1244807	JAN	10397	1039707	ATL	1553.0	1500-1559	1832.0	341.0	NaN
7	1	2	9E	20363	9E	N295PQ	3287	12953	1295304	LGA	11193	1119302	CVG	1551.0	1500-1559	1824.0	585.0	NaN
8	1	2	9E	20363	9E	N337PQ	3288	12451	1245102	JAX	12953	1295304	LGA	1037.0	1000-1059	1239.0	833.0	NaN
9	1	2	9E	20363	9E	N311PQ	3289	10397	1039707	ATL	10685	1068502	BMI	1245.0	1200-1259	1318.0	533.0	NaN

	DAY_OF_MONTH	DAY_OF_WEEK	OP_UNIQUE_CARRIER	OP_CARRIER_AIRLINE_ID	OP_CARRIER	TAIL_NUM	OP_CARRIER_FL_NUM	ORIGIN_AIRPORT_ID	ORIGIN_AIRPORT_SEQ_ID	ORIGIN	DEST_AIRPORT_ID	DEST_AIRPORT_SEQ_ID	DEST	DEP_TIME	DEP_DEL15	DEP_TIME_BLK	ARR_TIME	ARR_DEL15	DISTANCE	Unnamed: 21
583975	31	4	UA	19977	UA	N813UA	205	14771	1477104	SFO	14057	1405702	PDX	604.0	0.0	0600-0659	802.0	0.0	550.0	NaN
583976	31	4	UA	19977	UA	N75861	204	13930	1393007	ORD	12892	1289208	LAX	813.0	1.0	0700-0759	1028.0	0.0	1744.0	NaN
583977	31	4	UA	19977	UA	N39728	203	10693	1069302	BNA	12266	1226603	IAH	1105.0	0.0	1100-1159	1335.0	1.0	657.0	NaN
583978	31	4	UA	19977	UA	N779UA	202	13930	1393007	ORD	13830	1383002	OGG	1027.0	1.0	1000-1059	1457.0	0.0	4184.0	NaN
583979	31	4	UA	19977	UA	N769UA	201	12173	1217305	HNL	12016	1201602	GUM	1502.0	0.0	1500-1559	1849.0	0.0	3801.0	NaN
583980	31	4	UA	19977	UA	N776UA	200	12016	1201602	GUM	12173	1217305	HNL	749.0	0.0	0700-0759	1832.0	0.0	3801.0	NaN
583981	31	4	UA	19977	UA	N36280	174	12016	1201602	GUM	14955	1495503	SPN	717.0	0.0	0700-0759	759.0	0.0	129.0	NaN
583982	31	4	UA	19977	UA	N36280	117	14955	1495503	SPN	12016	1201602	GUM	857.0	0.0	0900-0959	933.0	0.0	129.0	NaN
583983	31	4	UA	19977	UA	N39726	105	14955	1495503	SPN	12016	1201602	GUM	1820.0	0.0	1800-1859	1854.0	0.0	129.0	NaN
583984	31	4	UA	19977	UA	N39726	104	12016	1201602	GUM	14955	1495503	SPN	1636.0	0.0	1600-1659	1719.0	0.0	129.0	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks